DatePart example

DatePart('yyyy',[OrderDate])
(where yyyy is the four-digit number of year, and [OrderDate]
is the field name).

[OrderDate]=3-Jul-96

Result: 1996